Modifying Column Options for Grids
You can customize your Query table to display columns of your choosing, rearrange the order of columns, hide, and also mark columns as "read-only".
Follow these steps to edit the column options for a grid.
- Open Query Browser.
-
Select the Query that you want to work on, and then click
Column options for grid (
).
The
Column Options dialog appears,
listing all visible grid columns for the selected Query. For example,
-
To remove a column, click
Hide (
).
For example,
The selected column is hidden in the grid.
-
To add hidden columns to the grid, click the
Add icon (
) next to
Add column(s) and then click
Add column(s).
For example,
The hidden Class appears.
-
Select the Class and then click
Add icon (
).
The column(s) are added to the bottom of the list.
- You can rearrange the order of columns by selecting the row that represents the column you want to move, and then dragging and dropping it into the desired position. For example,
-
To prevent users from editing contents in a column, click the
ReadOnly icon (
) to change the column to
read-only status.
The icon changes to
Editable (
) and no changes can be made to
the column in the grid. For example,
-
To freeze one or more columns, select a column, and click the
Freeze icon (
).
The icon changes to Unfreeze (
).
Frozen columns remain visible while scrolling through the Class table. A dark vertical border separates frozen and unfrozen columns. For example,
-
To unfreeze a column, click
Unfreeze (
), and then click
Save.
-
When you are finished, click
Save and close the dialog.
The grid is updated with your selections.
